Mapping accounts

This dimension is a table that stores the general ledger chart of accounts. This table is used by Financial Reporting, Instrument Data Mart, DQA, and FTP.

At the top of the page, the system displays when the table was last updated. You can perform the following actions to manage your account records:

  • Edit existing accounts directly in the table.

  • Add one or more new accounts directly in the table.

  • Manage the list of accounts outside the system by downloading the table to Excel, make your changes, and then upload the table to the system. This allows you to make larger changes more easily. For more information, see Editing a dimension using a spreadsheet.

  • Download a template of the table to add accounts. For example, when you are performing the initial system setup.

Adding or editing an account

NOTE: The system can only display up to a maximum of 10,000 records. Use the filter to increase or decrease the records returned in the table.

To add or edit an account:

  1. On the Manage Data tab of the System Administration page, click the Accounts sub-tab.

  2. Click Open.

  3. In the table, do any of the following:

    • To add a single account, click Add Row. The new row displays at the bottom of the table. Enter information in each column. After you save, the table will display the new row in order by the ACCT column.

      NOTE: You can optionally add multiple accounts by clicking Add Rows. This displays the Add Rows dialog box, where the system will prompt you to enter the number of rows to add.

      IMPORTANT: If you add a new record that already exists in the table, the system will overwrite the original column values with your new entries when you save your changes. We recommend that you review your entries before saving any changes.

    • To edit an account, click in the cell(s) to make your changes.

    • To undo your changes, click the left arrow icon.
    • To redo your changes, click the right arrow icon .
  4. When you finish making changes, click Save.

Deleting an account

IMPORTANT: If the record is currently used in the system or has historical data assigned to it, Axiom may not allow you to delete the record.

To delete an account:

  1. On the Manage Data tab of the System Administration page, click the Accounts sub-tab.

  2. Click Open.

  3. In the table, select the row to highlight it, and then click Delete Row.

  4. At the confirmation prompt, click OK.
  5. When you finish making changes, click Save.

Filtering records

To filter records:

  1. Click the funnel icon in the upper left corner of the page.

    TIP: To keep the Filter panel open and in place, click the thumbtack icon in the upper right corner of the panel. To close the panel, click the thumbtack icon again.

  2. In the Maximum Records (Up to 10,000) field, type the number of records to display (up to 10,000).
  3. In the Filter box, you can narrow down the records to display by selecting or creating a filter using the Filter Wizard. To access the Filter Wizard, click Edit. If you are familiar with writing filter statements, you can type the statement syntax directly in the Filter box. For more information, see Filter criteria syntax.
  4. Click Apply.

Column descriptions

For column descriptions, see Accounts dimension.